Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# AUDIT_TRAIL

Property | Description
--- | ---
Parameter type | String
Syntax | `AUDIT_TRAIL = { none | os | db | db,extended | xml | xml,extended }`
Default value | `none`
Modifiable | No
Basic | No

`AUDIT_TRAIL` enables or disables database auditing.

Values:

- `none`

  Disables database auditing.

- `os`

  Enables database auditing and directs all audit records to the operating system's audit trail.

- `db`

  Enables database auditing and directs all audit records to the database audit trail (the `SYS.AUD$` table).

- `db,extended`

  Enables database auditing and directs all audit records to the database audit trail (the `SYS.AUD$` table). In addition, populates the `SQLBIND` and `SQLTEXT` CLOB columns of the `SYS.AUD$` table.

- `xml`

  Enables database auditing and writes all audit records to XML format OS files.

- `xml``,extended`

  Enables database auditing and prints all columns of the audit trail, including SqlText and SqlBind values.

You can use the SQL statement `AUDIT` to set auditing options regardless of the setting of this parameter.